Lista referencji diagramu

Name

Code

Parent Table

Child Table

Foreign Key Columns

Parent Role

Child Role

R_2877

R_2877

CO_CATERINGORDER

CO_CATERINGORDERITEM

CO_CATERINGORDERID

 

 

R_2879

R_2879

CO_DICTKITCHEN

CO_DICTKITCHENFREEDAY

CO_DICTKITCHENID

 

 

R_2880

R_2880

CO_DICTUNIT

CO_DICTNUTRIENT

CO_DICTUNITID

 

 

R_2882

R_2882

CO_DICTNUTRIENT

CO_DIETNUTRIENT

CO_DICTNUTRIENTID

 

 

R_2883

R_2883

CO_CATERINGORDER

CO_INVOICE

CO_CATERINGORDERID

 

 

R_2884

R_2884

CO_DICTKITCHEN

CO_L_DICTDIETDICTKITCHEN

CO_DICTKITCHENID

 

 

R_2885

R_2885

CO_DICTNUTRIENT

CO_L_DICTPRODUCTDICTNUTRIENT

CO_DICTNUTRIENTID

 

 

R_2886

R_2886

CO_DICTPRODUCT

CO_L_DICTPRODUCTDICTNUTRIENT

CO_DICTPRODUCTID

 

 

R_2887

R_2887

CO_DICTPRODUCTPROCESSING

CO_L_DICTPRODUCTDICTNUTRIENT

CO_DICTPRODUCTPROCESSINGID

 

 

R_2888

R_2888

CO_DICTPRODUCTPROCESSING

CO_L_DICTPRODUCTPROCESSING

CO_DICTPRODUCTPROCESSINGID

 

 

R_2889

R_2889

CO_DICTPRODUCT

CO_L_DICTPRODUCTPROCESSING

CO_DICTPRODUCTID

 

 

R_2890

R_2890

CO_DICTCONSUMER

CO_L_RECIPEDICTCONSUMER

CO_DICTCONSUMERID

 

 

R_2891

R_2891

CO_RECIPE

CO_L_RECIPEDICTCONSUMER

CO_RECIPEID

 

 

R_2892

R_2892

CO_RECIPE

CO_L_RECIPEDICTDIET

CO_RECIPEID

 

 

R_2893

R_2893

CO_DICTNUTRIENT

CO_L_RECIPEDICTNUTRIENT

CO_DICTNUTRIENTID

 

 

R_2894

R_2894

CO_RECIPE

CO_L_RECIPEDICTNUTRIENT

CO_RECIPEID

 

 

R_2895

R_2895

CO_DICTUNIT

CO_L_RECIPEDICTNUTRIENT

CO_DICTUNITID

 

 

R_2899

R_2899

CO_MENU

CO_MENUITEM

CO_MENUID

 

 

R_2902

R_2902

CO_ORDERSTATUS

CO_ORDER

ORDERSTATUSID

 

 

R_2903

R_2903

CO_ORDER

CO_ORDERITEM

ORDERID

 

 

R_2905

R_2905

CO_ORDERSTATUS

CO_ORDERSTATUSTEXT

ORDERSTATUSID

 

 

R_2906

R_2906

CO_DICTPRODUCT

CO_PRODUCT

CO_DICTPRODUCTID

 

 

R_2907

R_2907

CO_DICTUNIT

CO_PRODUCT

CO_RECIPEDICTUNITID

 

 

R_2908

R_2908

CO_DICTUNIT

CO_PRODUCT

CO_STORAGEDICTUNITID

 

 

R_2911

R_2911

CO_DICTPRODUCT

CO_RECIPEINGREDIENT

CO_DICTPRODUCTID

 

 

R_2912

R_2912

CO_RECIPE

CO_RECIPEINGREDIENT

CO_RECIPEID

 

 

R_2913

R_2913

CO_DICTUNIT

CO_RECIPEINGREDIENT

CO_DICTUNITID

 

 

R_2914

R_2914

CO_DICTPRODUCTPROCESSING

CO_RECIPEINGREDIENT

CO_DICTPRODUCTPROCESSINGID

 

 

R_2921

R_2921

CO_SUBSCRIPTIONPERSON

CO_SUBSCRIPTION

CO_SUBSCRIPTIONPERSONID

 

 

R_2922

R_2922

CO_SUBSCRIPTION

CO_SUBSCRIPTIONDAY

CO_SUBSCRIPTIONID

 

 

R_2924

R_2924

CO_DICTCONSUMER

CO_SUBSCRIPTIONPERSON

CO_DICTCONSUMERID

 

 

R_2925

R_2925

CO_DICTCONSUMER

CO_SUBSCRIPTIONPRICE

CO_DICTCONSUMERID

 

 

R_2928

R_2928

CO_SUBSCRIPTIONPERSON

CO_SUBSCRIPTIONREFUND

CO_SUBSCRIPTIONPERSONID

 

 

R_2929

R_2929

CO_SUBSCRIPTION

CO_SUBSCRIPTIONREFUND

CO_PREVSUBSCRIPTIONID

 

 

R_2930

R_2930

CO_SUBSCRIPTION

CO_SUBSCRIPTIONREFUND

CO_CURRSUBSCRIPTIONID

 

 

R_2931

R_2931

CO_DICTUNIT

CO_RECIPE

PortionUnitID

 

 

R_2932

R_2932

Co_KitchenType

Co_KitchenTypeText

KitchenTypeId

 

 

R_2933

R_2933

Co_KitchenType

CO_DICTKITCHEN

KitchenTypeId

 

 

R_9649

R_9649

CO_DISH

CO_RECIPE

CO_DISHID

 

 

R_9650

R_9650

CO_DISHCATEGORY

CO_L_DISHDISHCATEGORY

CO_DISHCATEGORYID

 

 

R_9651

R_9651

CO_DISH

CO_L_DISHDISHCATEGORY

CO_DISHID

 

 

R_9677

R_9677

CO_STOCKORDERSTATUS

CO_STOCKORDER

STOCKORDERSTATUSID

 

 

R_9678

R_9678

CO_DICTKITCHEN

CO_STOCKORDER

KITCHENID

 

 

R_9680

R_9680

CO_STOCKORDER

CO_STOCKORDERITEM

STOCKORDERID

 

 

R_9681

R_9681

CO_DICTUNIT

CO_STOCKORDERITEM

DICTUNITID

 

 

R_9682

R_9682

CO_STOCKORDER

CO_L_STOCKORDERORDERITEM

CO_STOCKORDERID

 

 

R_9683

R_9683

CO_ORDERITEM

CO_L_STOCKORDERORDERITEM

CO_ORDERITEMID

 

 

R_9684

R_9684

CO_STOCKORDER

CO_STOCKORDERMEAL

CO_STOCKORDERID

 

 

R_9722

R_9722

CO_DICTKITCHEN

CO_DELIVERY

CO_KITCHENID

 

 

R_9725

R_9725

CO_DELIVERY

CO_DELIVERYITEM

CO_DELIVERYID

 

 


2